Calculated (formula) attribute
Description
A calculated attribute determines the value of the wrapped data field using a formula. This formula determines the possible values (characteristics) of the calculated attribute.
The formula is only evaluated at the time of the query of the calculated attribute. Only then is the captured formula calculated. As with the evaluation of any formula in ClassiX®, it may happen that variables are specified in the formula expression that are not automatically found by the system. When creating the formula, it is therefore important to ensure that the calculated attribute is later used in a context in which the formula can be evaluated.
The formula can be tested directly in the input window, the required variables are then interactively queried by the system. (see menu item "Test calculated attribute" or corresponding button)
In the standard case (formula type = individual) the formula is written directly into the calculated attribute.
The syntax of formulas can be found under calculation formulas.
You can find more information in the topic Features.
Functionality
Input window
This window is used to maintain the calculated attribute.
Menu item | Description |
---|---|
Edit | - |
Attributes | - |
: : Select dynamic data field | Selection of the dynamic data field (slots) itself, which is to be described by the calculated attribute. A dynamic data field must be specified. Can only be selected when a calculated attribute is entered again. |
: : Select prefix | Selection of the prefix of a dynamic data field (slots), which is to be described by the calculated attribute. A prefix does not have to be set. Can only be selected when entering a new calculated attribute. |
Option Formula type | - |
: : Individual | (standard setting), a separate formula is stored in the calculated attribute |
: : General | refers to a calculation formula already stored in the system. This case can be useful if some of the calculated attributes should have different names, controls or validities, for example, but the formula should always be the same. |
General formula | This menu item is only active if the calculated attribute has the formula type "General" (see menu item "Option formula type"). Then you can choose between "Edit" (direct call of the referenced formula for editing) and "Select" (selection of a calculation formula stored in the system to link it with the calculated attribute). |
: Test calculated attribute | The (saved!) calculated attribute can be tested with regard to the result of the stored formula. The variables specified in the formula are interactively queried by the system. |
Close | Close window |
Search | Call up list window |
Symbol | Description |
---|---|
The input window is cleared. | |
Changes to the attribute object are saved. | |
The displayed attribute object is deleted. | |
The print window is opened. | |
The input window for the validity of the attribute is opened. | |
The window for testing the formula is opened. | |
Open first document directory | |
Open associations |
Field | Description |
---|---|
Data field/prefix | Dynamic data field with/without prefix of the calculated attribute |
Editor | Information of the editor |
Control system | How to control the attribute |
Description | Description of the calculated attribute |
Text internal | Internal information of the calculated attribute |
Value check | Activation and definition of conditions/restrictions for the attribute value. If the value entered at does not meet the restrictions specified in the value check, a corresponding dialogue window appears, informing the user of his input error. It is also possible to set complex conditions which are not limited to the current attribute. However, it must be ensured that the attributes addressed can be found in the later environment (plug space). |
Formula | Formula used |
Output window | Graphically prepared output of the formula |
button | Description |
---|---|
Data field | Call up selection window for dynamic data fields |
prefix | Call up the selection window for prefixes |
Editor | Call up selection window for employees |
Formula | Open the selection window for formulas. (Only active if menu item "Formula type option" is set to "General") |
Edit | The XML representation of the formula generated by the transformation can be viewed and edited |
Properties | The properties of the XML control can be edited. |
OK | Changes to the attribute object are saved. If no changes have been made, the button is locked. |
New | The input window is cleared. |
Delete | The displayed attribute object is deleted. |
Close | The window is closed without saving changes. If you want to save the changes, you must press the "OK" button. |
List window
Serves to list the attribute objects.
Symbol | Description |
---|---|
The input window is called to create a new attribute. | |
The selected attribute object is displayed in the input window. | |
The selected attribute object is deleted. | |
The print window is opened. | |
The input window for the validity of the attribute is opened. | |
All attributes are copied to the clipboard. | |
All selected attributes are exported to Excel. |
Field | Description |
---|---|
Attribute name | Search by name of the dynamic data field of the attribute |
Description | Search in the description of the attributes |
Text internal | Search in the internal text of the attributes |
Category | Search by means of the categorisation (of the order term) of the attributes |
button | Description |
---|---|
Edit | The selected attribute object is displayed in the input window. |
New | An empty input window opens. |
Delete | The selected attribute object is deleted. |
Close | The window is closed. |
Related topics
Technical documentation
- Overview of features
- Implementation
- Quality assurance
- Calculated attribute Editing module
- Calculated attributes Selection module
Calculated attribute Editing module
Module name
attrfedt.mod
Classes
Security
In addition to restricting access rights via the class and its data fields, the module can be restricted in its use via some of the received messages.
Message | Parameters | Function | Security |
---|---|---|---|
ATTRIBUTE_CHANGED | Attribute object | Attribute has been changed | |
ATTRIBUTE_CREATED | Attribute object | Attribute was created | |
ATTRIBUTE_DELETED | Attribute object | Attribute was deleted | |
EDIT_ATTRIBUTE | NULL or attribute object | Call up the input window for attributes | |
EDIT_FORMULA_ATTRIBUTES | NULL or calculated attribute object | Open the input window for calculated attributes | |
FORMULA_ATTRIBUTE_CHANGED | Calculated attribute object | Calculated attribute was changed | |
FORMULA_ATTRIBUTE_CREATED | Calculated attribute object | Calculated attribute was generated | |
FORMULA_ATTRIBUTE_DELETED | Calculated attribute object | Calculated attribute was deleted | |
FORMULA_CHANGED | Formula object | Formula has been changed | |
FORMULA_CREATED | Formula object | Formula was generated | |
FORMULA_DELETED | Formula object | Formula was deleted | |
FORMULA_SELECTED | Formula object | Formula was selected | |
LIST_ATTRIBUTE | Collection attribute objects or NULL | Call up list window for attributes | |
LIST_FORMULA_ATTRIBUTES | Collection Calculated attribute objects or NULL | Open list window for calculated attributes | |
LOAD_FORMULA_ATTRIBUTES | none | Load calculated attributes | |
SLOT_SELECTED | Dynamic data field object | Dynamic data field was selected |
Message | Parameters | Function | Receiver module |
---|---|---|---|
EDIT_ATTRIBUTE | NULL or attribute object | Call up input window for attribute | Attribute Editing Module |
EDIT_FORMULA | NULL or formula object | Open the input window for formula | Formula Editing Module |
EDIT_VALIDITY_BY_DATE | Window title, object, recipient of the reply | Call up the input window for validity | Validity Editing Module |
LIST_FORMULA | NULL or collection of formula objects | Call up list window for formulas | Formula Editing Module |
LIST_FORMULA_ATTRIBUTES | NULL or collection of calculated attribute objects | Call up list window for attributes | Attribute Editing Module |
SELECT_FORMULA | NULL or collection of formula objects | Call up selection window for formulas | Formula selection module |
SELECT_SLOT | Widget | Call up selection window for dynamic data fields | Dynamic data field selection module |
SHOW_PREVIEW | Widget | Print Preview | Print Preview |
TEST_FORMULA |
Calculated attributes Selection module
Module name
attrfsel.mod
Classes
Security
In addition to restricting access rights via the class and its data fields, the module can be restricted in its use via some of the received messages.
Message | Parameters | Function | Security |
---|---|---|---|
ATTRIBUTE_CHANGED | Attribute object | Attribute has been changed | |
ATTRIBUTE_CREATED | Attribute object | Attribute was created | |
ATTRIBUTE_DELETED | Attribute object | Attribute was deleted | |
SELECT_ATTRIBUTES | Collection attribute objects or NULL, recipient of the response | Call up selection window for attribute | |
SELECT_FORMULA_ATTRIBUTES | Collection Calculated attribute objects or NULL, recipient of the response | Call up the selection window for calculated attributes |
Message | Parameters | Function | Receiver module |
---|---|---|---|
ATTRIBUTE_SELECTED | Attribute object, recipient | Attribute was selected | |
EDIT_ATTRIBUTE | NULL or attribute object | Call up input window for attribute | Attribute Editing Module |
FORMULA_ATTRIBUTE_SELECTED | Calculated attribute object, recipient | Calculated attribute was selected |